<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_userid_job`;");
CreateTable("CREATE TABLE `phpyun_userid_job` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `job_id` int(11) NOT NULL,
  `job_name` varchar(150) NOT NULL,
  `com_id` int(11) NOT NULL,
  `com_name` varchar(150) NOT NULL,
  `eid` int(10) unsigned NOT NULL,
  `datetime` int(10) NOT NULL,
  `type` int(1) NOT NULL DEFAULT '1',
  `is_browse` int(1) NOT NULL DEFAULT '1',
  `body` varchar(255) DEFAULT NULL,
  `did` int(11) DEFAULT NULL,
  `quxiao` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `jobid` (`job_id`),
  KEY `comid` (`com_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>